DECLARE @Store AS TABLE (ID INT PRIMARY KEY IDENTITY(1,1), Store VARCHAR(25))
INSERT INTO @Store (Store) VALUES ('SAFEWAY'),('ALBERTSONS'),('711')
SELECT * FROM @Store

DECLARE @Product AS TABLE (ID INT PRIMARY KEY IDENTITY(1,1), FK_STOREID INT, ProductName VARCHAR(25))
INSERT INTO @Product (FK_STOREID,ProductName) VALUES (1,'TURKEY'),(1,'GRAVY'),(2,'STUFFING')
SELECT * FROM @Product


SELECT  *
FROM	   @Product AS P
	   RIGHT OUTER JOIN @Store AS S ON (P.FK_STOREID = S.ID)